<%-- 
    Document   : viewcollegedetails
    Created on : Apr 27, 2012, 11:52:06 PM
    Author     : Ajay Kumar "Mukund"
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">


<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn"%>
<%
                              try{
                              Connection con=Dbconn.getConn();
                              Statement st=con.createStatement();
                              String clgid=request.getParameter("clgid");
                              ResultSet rs=st.executeQuery("select * from college where clgid='"+clgid+"' ");
                              while(rs.next()) {



 %>


<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="tbl_bdr">
  <tr>
    <td align="center" valign="top"><img src="images/blank.gif" width="1" height="0" border="0" /><br />

  <tr>
    <td width="49%" height="31" align="left" valign="top" style="padding-left:3px; padding-top:3px; padding-bottom:3px;">
	<table width="99%" bgcolor="#FFFFFF" style="padding-right:0px;" class="tbl_bdr">
  <tr style="padding-top:10px;">
    <td colspan="3" height="28"><div  class="mainheading_emp" style="float:left; text-transform:capitalize;">College Details</div></td>
    </tr>
  <tr style="padding-top:10px;">
    <td colspan="3"><img src="src/getpic.jsp?id=<%=rs.getString("clgid")%>&table=college&col=logo&pk_col=clgid" width="138" height="35" border="0" /></td>
    </tr>
  <tr style="padding-top:10px;">
    <td width="18%" height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">College Name</span></td>
    <td width="1%" >:</td>
    <td width="27%" ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("clgname") %></span></td>
  </tr>
  <tr style="padding-top:10px;">
    <td width="18%" height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">TPO Name</span></td>
    <td width="1%" >:</td>
    <td width="27%" ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("tponame") %></span></td>
    </tr>
  <tr style="padding-top:10px;">
    <td height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">TPO email </span></td>
    <td >:</td>
    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("tpoemail") %></span></td>
    </tr>
  <tr style="padding-top:10px;">
    <td height="28"> <span class="tbl_pfl_txt" style="padding-left:10px;">University Name</span></td>
    <td >:</td>
    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("uname") %></span></td>
    </tr>
  <tr style="padding-top:10px;">
    <td height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">Website (url) </span></td>
    <td >:</td>
    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("url") %></span></td>
    </tr>
  
  <tr >
    <td height="40" ><span class="tbl_pfl_txt" style="padding-left:10px;">Address</span></td>
    <td >:</td>
    <td ><span style="padding-left:5px;" class="tbl_pfl_txt">
      <%=rs.getString("address") %>    </span></td>
    </tr>
  <tr >
    <td colspan="12" ><div style="background:#FFFFFF; width:100%" >


	<table  width="100%" bgcolor="#FFFFFF" style="padding-right:0px;">

   <tr>
    <td > <font color='#0099FF' size='+2'><strong>College Profile:</strong></font></td>
    </tr>

  <tr >
    <td style="padding-left:10px;" ><p>&nbsp;</p>
      <p><%=rs.getString("clgprofile") %>  &nbsp;</p></td>
  </tr>
  <tr >
    <td></td>
  </tr>
  

   <tr >
    <td ></td>
  </tr>
</table>
    </div></td>
  </tr>
  </table>

    </td>
  </tr>



 <tr>
    <td colspan="2" align="left" valign="top"  class="tbl_bdr">
	<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" style="padding-right:0px;">
      <tr valign="middle">
        <td height="28" colspan="3"><font color='#0099FF' size='+2'><strong>Contact Details</strong></font></div></td>
        <td width="12%" height="28"></td>
        </tr>
      <tr>
        <td width="17%" height="29" valign="middle"   style="padding-left:8px;"><div align="left"><strong>TPO Name</strong></div></td>
        <td width="1%" valign="middle"   style="padding-left:8px;">:</td>
        <td height="29" colspan="2" align="left" valign="middle" ><%=rs.getString("tponame") %>  </td>
        </tr>
      <tr>
        <td height="29" valign="middle" style="padding-left:8px;"><div align="left"><strong>Mobile Number </strong></div></td>
        <td height="29" valign="middle" style="padding-left:8px;">:</td>
        <td height="29" colspan="2" align="left" valign="middle" ><%=rs.getString("mobile") %></td>
        </tr>

      <tr>
        <td height="29" valign="middle"  style="padding-left:8px;"><strong>Contact</strong></td>
        <td height="29" valign="middle"  style="padding-left:8px;">:</td>
        <td height="29" colspan="2" align="left" valign="middle"><%=rs.getString("contact") %></td>
      </tr>
      <tr>
        <td height="29" valign="middle"  style="padding-left:8px;"><div align="left"><strong>Fax Number </strong></div></td>
        <td height="29" valign="middle"  style="padding-left:8px;">:</td>
        <td height="29" colspan="2" align="left" valign="middle"><%=rs.getString("fax") %>  </td>
        </tr>
    </table>

	</td>
    </tr>
  <tr>
    <td colspan="2" align="left" valign="middle" height="1px"></td>
  </tr>
  <tr>
    <td colspan="2" align="left" valign="middle" style="padding-left:3px; padding-top:3px; padding-bottom:3px;">


	</td>
  </tr>

</table>
</td>
<%} }
                              catch(Exception e)
                                      {
                                  out.println(e);
                                       }
 %>
 